package com.mrjoew.weekend.entities;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;
import org.hibernate.annotations.SQLDelete;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

/**
 * @author Christopher Jones
 * @explain
 * @date 2020/11/26 0026 18:54
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
@EqualsAndHashCode(callSuper = false)
@SQLDelete(sql = "UPDATE `sys_menu` SET deleted = 1 WHERE id = ?")
@Entity
@Table(name = "cgn_staff")
public class CgnStaff extends BasePO {

    @Column(name = "hr_personnel_dept_id", columnDefinition = "varchar(128) comment '工作部门'")
    private String hrPersonnelDeptId;

    @Column(name = "staff_short_py", columnDefinition = "varchar(128) comment '排序拼音'")
    private String staffShortPy;

    @Column(name = "hr_personnel_langu_id", columnDefinition = "varchar(128)")
    private String hrPersonnelLanguId;

    @Column(name = "co_id_mark", columnDefinition = "varchar(128)")
    private String coIdMark;

    @Column(name = "co_create_time", columnDefinition = "varchar(128)")
    private String coCreatetime;

    @Column(name = "staff_action_type_id", columnDefinition = "varchar(32)")
    private String staffActionTypeId;

    @Column(name = "hr_personnel_dept", columnDefinition = "varchar(128)")
    private String hrPersonnelDept;

    @Column(name = "staff_id_type_id", columnDefinition = "varchar(32)")
    private String staffIdTypeId;

    @Column(name = "staff_native", columnDefinition = "varchar(128)")
    private String staffNative;

    @Column(name = "czsj", columnDefinition = "varchar(128)")
    private String czsj;

    @Column(name = "staff_no", columnDefinition = "varchar(128) comment '员工编号'")
    private String staffNo;

    @Column(name = "staff_from_unit_id", columnDefinition = "varchar(128)")
    private String staffFromUnitId;

    @Column(name = "co_desc", columnDefinition = "varchar(128)")
    private String coDesc;

    @Column(name = "staff_p_code_id", columnDefinition = "varchar(128)")
    private String staffPcodeId;

    @Column(name = "tran_staff_no", columnDefinition = "varchar(128) comment '员工工号'")
    private String tranStaffNo;

    @Column(name = "staff_kostl", columnDefinition = "varchar(32)")
    private String staffKostl;

    @Column(name = "co_createorg", columnDefinition = "varchar(128) comment '创建组织'")
    private String coCreateorg;

    @Column(name = "tenent_id", columnDefinition = "varchar(32)")
    private String tenentId;

    @Column(name = "staff_addr", columnDefinition = "varchar(128) comment '员工地址'")
    private String staffAddr;

    @Column(name = "infotype", columnDefinition = "varchar(128) comment '信息来源'")
    private String infotype;

    @Column(name = "staffsubrange", columnDefinition = "varchar(128)")
    private String staffsubrange;

    @Column(name = "co_creater", columnDefinition = "varchar(128) comment '创建人ID'")
    private String coCreater;

    @Column(name = "cl_id", columnDefinition = "varchar(32)")
    private String clId;

    @Column(name = "staff_status_id", columnDefinition = "varchar(32) comment '员工状态ID'")
    private String staffStatusId;

    @Column(name = "staff_gh_time", columnDefinition = "varchar(128)")
    private String staffGhtime;

    @Column(name = "staff_id_type", columnDefinition = "varchar(128) comment '员工ID类型'")
    private String staffIdType;

    @Column(name = "staff_name", columnDefinition = "varchar(128) comment '员工姓名'")
    private String staffName;

    @Column(name = "staff_id_card", columnDefinition = "varchar(128) comment '员工ID编号'")
    private String staffIdCard;

    @Column(name = "staff_birthday", columnDefinition = "varchar(128) comment '员工生日'")
    private String staffBirthday;

    @Column(name = "staff_action_type", columnDefinition = "varchar(128) comment '招聘'")
    private String staffActionType;

    @Column(name = "staff_dutyrank", columnDefinition = "varchar(128)")
    private String staffDutyrank;

    @Column(name = "co_modify_dept", columnDefinition = "varchar(128) comment '变更部门'")
    private String coModifydept;

    @Column(name = "staff_status", columnDefinition = "varchar(128) comment '员工状态'")
    private String staffStatus;

    @Column(name = "staff_marital_status", columnDefinition = "varchar(128)")
    private String staffMaritalstatus;

    @Column(name = "staff_kostl_ltest", columnDefinition = "varchar(128) comment '员工岗位?'")
    private String staffKostlLtext;

    @Column(name = "staff_prctr", columnDefinition = "varchar(32)")
    private String staffPrctr;

    @Column(name = "staff_dept_id", columnDefinition = "varchar(128) comment '员工部门ID'")
    private String staffDeptId;

    @Column(name = "staff_ctr_cgn_manager", columnDefinition = "varchar(128) comment '员工领导'")
    private String staffCtrCgnManager;

    @Column(name = "hr_staff_title_id", columnDefinition = "varchar(128) comment '职称'")
    private String hrStaffTitleId;

    @Column(name = "hr_personnel_posi_id", columnDefinition = "varchar(128) comment '职位'")
    private String hrPersonnelPosiId;

    @Column(name = "isdelete", columnDefinition = "varchar(32) comment '是否删除'")
    private String isdelete;

    @Column(name = "hr_personnel_posi", columnDefinition = "varchar(128) comment '职位'")
    private String hrPersonnelPosi;

    @Column(name = "ts", columnDefinition = "varchar(128)")
    private String ts;

    @Column(name = "staff_name_alias", columnDefinition = "varchar(128) comment '员工别名'")
    private String staffNameAlias;

    @Column(name = "co_submittime", columnDefinition = "varchar(128)")
    private String coSubmittime;

    @Column(name = "staff_persg", columnDefinition = "varchar(64)")
    private String staffPersg;

    @Column(name = "mobile_phone1", columnDefinition = "varchar(32) comment '电话号'")
    private String mobilePhone1;

    @Column(name = "staff_class", columnDefinition = "varchar(128)")
    private String staffClass;

    @Column(name = "staff_persk", columnDefinition = "varchar(64)")
    private String staffPersk;

    @Column(name = "staff_maritalstatus_id", columnDefinition = "varchar(32) comment '员工婚姻状况ID'")
    private String staffMaritalstatusId;

    @Column(name = "staffsubrange_id", columnDefinition = "varchar(32)")
    private String staffsubrangeId;

    @Column(name = "countrycode", columnDefinition = "varchar(32) comment '城市代码'")
    private String countrycode;

    @Column(name = "co_id", columnDefinition = "varchar(32)")
    private String coId;

    @Column(name = "telephone_no1", columnDefinition = "varchar(128) comment '电话号码'")
    private String telephoneNo1;

    @Column(name = "staff_dept", columnDefinition = "varchar(128) comment '员工部门'")
    private String staffDept;

    @Column(name = "dr", columnDefinition = "varchar(32)")
    private String dr;

    @Column(name = "staff_search_condition", columnDefinition = "varchar(255) comment '搜索'")
    private String staffSearchCondition;

    @Column(name = "address_office", columnDefinition = "varchar(128) comment '办公地址'")
    private String addressOffice;

    @Column(name = "staff_workunit", columnDefinition = "varchar(128) comment '工作单位'")
    private String staffWorkunit;

    @Column(name = "staff_ctr_leavetime", columnDefinition = "varchar(128)")
    private String staffCtrLeavetime;

    @Column(name = "co_submituser", columnDefinition = "varchar(128)")
    private String coSubmituser;

    @Column(name = "co_create_dept", columnDefinition = "varchar(128)")
    private String coCreatedept;

    @Column(name = "personnels_id", columnDefinition = "varchar(32)")
    private String personnelsId;

    @Column(name = "co_systemid", columnDefinition = "varchar(128)")
    private String coSystemid;

    @Column(name = "staff_health", columnDefinition = "varchar(128) comment '健康状况'")
    private String staffHealth;

    @Column(name = "staff_zzwlb", columnDefinition = "varchar(128)")
    private String staffZzwlb;

    @Column(name = "staff_sex", columnDefinition = "varchar(32) comment '员工性别'")
    private String staffSex;

    @Column(name = "co_valid", columnDefinition = "varchar(32)")
    private String coValid;

    @Column(name = "staff_hire_type_id", columnDefinition = "varchar(32)")
    private String staffHireTypeId;

    @Column(name = "co_modifyorg", columnDefinition = "varchar(128)")
    private String coModifyorg;

    @Column(name = "staff_maritaltime", columnDefinition = "varchar(128) comment '员工结婚日期'")
    private String staffMaritaltime;

    @Column(name = "staff_zhrzwmc", columnDefinition = "varchar(32)")
    private String staffZhrzwmc;

    @Column(name = "company_id", columnDefinition = "varchar(32)")
    private String companyId;

    @Column(name = "staff_workunit_id", columnDefinition = "varchar(128)")
    private String staffWorkunitId;

    @Column(name = "staff_politic_rank_erp", columnDefinition = "varchar(128) comment '职级'")
    private String staffPoliticRankErp;

    @Column(name = "co_manualcode", columnDefinition = "varchar(128)")
    private String coManualcode;

    @Column(name = "infotype_id", columnDefinition = "varchar(32)")
    private String infotypeId;

    @Column(name = "staff_hire_type", columnDefinition = "varchar(128) comment '招聘类型'")
    private String staffHireType;

    @Column(name = "hr_staff_title", columnDefinition = "varchar(128) comment '职称'")
    private String hrStaffTitle;

    @Column(name = "staff_ctr_oroperties_id", columnDefinition = "varchar(32)")
    private String staffCtrPropertiesId;

    @Column(name = "co_publishuser", columnDefinition = "varchar(128) comment '发布用户'")
    private String coPublishuser;

    @Column(name = "staff_action_date", columnDefinition = "varchar(128)")
    private String staffActionDate;

    @Column(name = "tran_staff_dept_id", columnDefinition = "varchar(32)")
    private String tranStaffDeptId;

    @Column(name = "co_publishtime", columnDefinition = "varchar(128)")
    private String coPublishtime;

    @Column(name = "staff_worktime", columnDefinition = "varchar(128)")
    private String staffWorktime;

    @Column(name = "company", columnDefinition = "varchar(128)")
    private String company;

    @Column(name = "tran_company_no", columnDefinition = "varchar(128)")
    private String tranCompanyNo;

    @Column(name = "co_modifyuser", columnDefinition = "varchar(128)")
    private String coModifyuser;

    @Column(name = "co_modifytime", columnDefinition = "varchar(128)")
    private String coModifytime;

    @Column(name = "co_xsdtqsj", columnDefinition = "varchar(128)")
    private String coXsdtqsj;

    @Column(name = "staff_ctr_properties", columnDefinition = "varchar(128)")
    private String staffCtrProperties;

    @Column(name = "isdelete_id", columnDefinition = "varchar(32)")
    private String isdeleteId;

    @Column(name = "staff_class_id", columnDefinition = "varchar(32)")
    private String staffClassId;

    @Column(name = "staff_pcode", columnDefinition = "varchar(128) comment '群众'")
    private String staffPcode;

    @Column(name = "staff_dutyrank_id", columnDefinition = "varchar(32)")
    private String staffDutyrankId;

    @Column(name = "staff_join_gnp", columnDefinition = "varchar(128)")
    private String staffJoinGnp;

    @Column(name = "staff_ctr_intime", columnDefinition = "varchar(128)")
    private String staffCtrIntime;

    @Column(name = "sub_staff_no", columnDefinition = "varchar(32)")
    private String subStaffNo;

    @Column(name = "staff_health_id", columnDefinition = "varchar(32)")
    private String staffHealthId;

    @Column(name = "staff_zzwlb_id", columnDefinition = "varchar(32)")
    private String staffZzwlbId;

    @Column(name = "staff_sex_id", columnDefinition = "varchar(32)")
    private String staffSexId;

    @Column(name = "staff_name_py", columnDefinition = "varchar(128) comment '员工姓名拼音'")
    private String staffNamePy;

    @Column(name = "jt_rank", columnDefinition = "varchar(128) comment '职称'")
    private String jtRank;

    @Column(name = "hr_personnel_langu", columnDefinition = "varchar(128) comment '姓名类型'")
    private String hrPersonnelLangu;
}
